Hi Jef

You are right, I think I answered myself seconds ago, I was checking on the node that does not own the resources.

Just one more question...I was trying to...

I'll answer myself 😉 ...

I was checking Configuration Manager on the other node, the one who does NOT own the package. When I moved to the other node, I...

barsuk (6/19/2009)

---

I work in the financial industry and while all of the above technical questions are important, I am trying to spend not more then 20 mins on them. What...

point is: As a production DBA, the DBA must still be able to review developer code and fix it if it is needing fixed, train the developer how to...

I do some coding for the maintenance of the server and the odd bit of troubleshooting but if at an interview for a DBA role and I was presented...

hi_abhay78 (6/18/2009)

---

as per MS best practices :

-> put data files on a separate physical Raid 1+0 drive

-> Put Log files on a separate physical Raid 1+0 drive

-> Put...

Forgot to give you these nice T-SQL queries; they will let you know compare and see if something changed at Cluster level

--To see cluster associated drives

SELECT * FROM sys.dm_io_cluster_shared_drives

--Check Node...

Run the backup from Query ANalyzer and see if still is failing ...

BACKUP My Database to disk = 'd:\MyBak.bak'

WITH INIT;

where "D" or whatever, is your drive

also, please check the permissions...

A good one, which maybe is no so technical 😉 ... why are you leaving your current job? ... is tricky, is you say "salary" could lead you to trouble,...

Tim (6/18/2009)

---

I have a OLTP database thats around 300 GB and is fairly busy. I need to install it on a server that only has 2 drives, a drive C...

jackiepenn (6/18/2009)

---

We have a script that ran fin in SQL 2000 - we have moved it to a dfferent server and now it is so slow that it won't complete...

Hi Richard

What I mean is that for one MS-SQL instance, you should validate the max db numbers in terms of server and RAM capabilities; of course, user connections plays a...

4 GB maximum database size, but there is no limit on the number of databases you can use in Express.

Having said that, I would based my use not in...

Please check here

http://www.mssqltips.com/tip.asp?tip=1687 <-- really nice

http://msdn.microsoft.com/en-us/library/ms189910.aspx

and here

http://msdn.microsoft.com/en-us/library/ms179410.aspx

have fun!

ps (6/18/2009)

---

The only cause of concern here is the network bandwidth as the DR site is geographically seperated. remember size of zipped file is 500mb. if you were to apply...